//   Copyright 2012,2013 Vaughn Vernon
//
//   Licensed under the Apache License, Version 2.0 (the "License");
//   you may not use this file except in compliance with the License.
//   You may obtain a copy of the License at
//
//       http://www.apache.org/licenses/LICENSE-2.0
//
//   Unless required by applicable law or agreed to in writing, software
//   distributed under the License is distributed on an "AS IS" BASIS,
//   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
//   See the License for the specific language governing permissions and
//   limitations under the License.

package com.saasovation.collaboration.application.forum;

import com.saasovation.collaboration.application.forum.data.PostData;
import com.saasovation.common.port.adapter.persistence.AbstractQueryService;
import com.saasovation.common.port.adapter.persistence.JoinOn;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;

import java.util.Collection;
import java.util.HashMap;
import java.util.Map;

public class PostQueryService extends AbstractQueryService {

    public PostQueryService(NamedParameterJdbcTemplate jdbcTemplate) {
        super(jdbcTemplate);
    }

    public Collection<PostData> allPostsDataOfDiscussion(String aTenantId, String aDiscussionId) {
        String sql = "select * from tbl_vw_post where tenant_id = :tenantId and discussion_id = :discussionId";
        Map<String, Object> params = new HashMap<>();
        params.put("tenantId", aTenantId);
        params.put("discussionId", aDiscussionId);
        return this.queryObjects(PostData.class,
                sql,
                new JoinOn(),
                params);
    }

    public PostData postDataOfId(String aTenantId, String aPostId) {
        String sql = "select * from tbl_vw_post where tenant_id = :tenantId and post_id = :postId";
        Map<String, Object> params = new HashMap<>();
        params.put("tenantId", aTenantId);
        params.put("postId", aPostId);
        return this.queryObject(PostData.class,
                sql,
                new JoinOn(),
                params);
    }
}
